error 9003 when attaching a database

您所在的位置:网站首页 mysql 9003 error 9003 when attaching a database

error 9003 when attaching a database

2023-02-22 08:21| 来源: 网络整理| 查看: 265

Hello,

Do you mean this error: The log scan number %S_LSN passed to log scan in database '%.*ls' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

As the message already says, one option is to restore the database from the last valid backup.

Other options is: - Detach the database - Rename/Move the log file - Attach the MDF database file without the LOG file; a new log will be created.

Olaf Helper

Blog Xing



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3